package com.hotel.tv.repositories.auth.query;

import com.autumn.domain.repositories.DefaultEntityRepository;
import com.autumn.mybatis.mapper.annotation.MapperViewSelect;
import com.hotel.tv.entities.auth.query.HotelUserByRoleQuery;
import org.springframework.stereotype.Repository;

/**
 * <p>
 * </p>
 *
 * @description TODO
 * @author: 老码农
 * @create: 2020-04-10 10:40
 **/
@Repository
@MapperViewSelect("SELECT a.id,b.role_id,a.user_name,a.nick_name,a.phone_number,a.email_address,"
        + "a.sex,a.head_portrait_path,a.birthday,a.status,a.is_sys_user,a.user_type,a.gmt_create," +
        "a.gmt_modified,a.user_type,a.organize_id"
        + " FROM sys_user AS a INNER JOIN sys_user_role AS b on a.id = b.user_id")
public interface HotelUserByRoleQueryRepository extends DefaultEntityRepository<HotelUserByRoleQuery> {

}
